IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tr_Project_Upd]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[tr_Project_Upd]
GO

CREATE PROCEDURE [dbo].[tr_Project_Upd]
	@ProjectName VARCHAR(MAX),
	@ProjectDescription VARCHAR(MAX),
	@ActiveInd BIT,
	@ProjectId UNIQUEIDENTIFIER
AS

UPDATE tr_Project SET 
	Name = @ProjectName,
	[Description] = @ProjectDescription,
	ActiveInd = @ActiveInd
WHERE 
	ProjectId = @ProjectId

